﻿CREATE TABLE [dbo].[MedExamItem]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY,
	[MedExamId] INT NOT NULL, 
    [ExamNo] NVARCHAR(50) NULL, 
    [ReportDate] NVARCHAR(50) NULL, 
    [ExamName] NVARCHAR(50) NULL, 
    [Prompt] NVARCHAR(1000) NULL, 
    [Content] NVARCHAR(1000) NULL
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'主键，自增长',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'MedExamItem',
    @level2type = N'COLUMN',
    @level2name = N'Id'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'所属检查单Id',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'MedExamItem',
    @level2type = N'COLUMN',
    @level2name = N'MedExamId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'检查单编号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'MedExamItem',
    @level2type = N'COLUMN',
    @level2name = N'ExamNo'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'报告时间',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'MedExamItem',
    @level2type = N'COLUMN',
    @level2name = N'ReportDate'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'检查名称',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'MedExamItem',
    @level2type = N'COLUMN',
    @level2name = N'ExamName'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'检查印象',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'MedExamItem',
    @level2type = N'COLUMN',
    @level2name = N'Prompt'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'检查内容所见',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'MedExamItem',
    @level2type = N'COLUMN',
    @level2name = N'Content'